Model Table BALANCE VERSION

This model dimension represents Group Consolidation reporting balance versions and is based on the IFS Cloud dimension DIM_REP_BALANCE VERSION. All models that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is master company, i.e. each master company structure has its own set of balance versions values.

Attributes

Attribute Description (where applicable)
Balance VersionBalance Version
Balance Version CodeBalance Version Code
Balance Version Code DescBalance Version Code Desc
Balance Version DescBalance Version Desc
Company CodeCompany Code
Conn Balance VersionConn Balance Version
Simulated Balance VersionSimulated Balance Version
Source TypeSource Type

USED BY MODEL(S)

Model Name
Group Consolidation

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
BALANCE VERSIONDIM_REP_BALANCE_VERSION_GC_TMDIM_REP_BALANCE_VERSION_BIDIM_REP_BALANCE_VERSIONOn Line